<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryRef" :inline="true">
      <el-form-item label="名称检索" prop="name">
        <el-input
          v-model="queryParams.name"
          placeholder="请输入名称"
          clearable
          style="width: 240px"
          @keyup.enter.native="handleQuery" />
      </el-form-item>
      <el-form-item label="状态" prop="status">
        <el-select
          v-model="queryParams.status"
          placeholder="状态"
          clearable
          style="width: 240px">
          <el-option
            v-for="dict in commonStatusOptions"
            :key="dict.id"
            :label="dict.text"
            :value="dict.id" />
        </el-select>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="search" @click="handleQuery" v-hasPermi="['system:dbClean:list']">搜索</el-button>
        <el-button icon="refresh" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          icon="plus"
          @click="handleCreate"
          v-hasPermi="['system:dbClean:create']">新增
        </el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="success"
          icon="edit"
          :disabled="single"
          @click="handleEdit"
          v-hasPermi="['system:dbClean:edit']">修改
        </el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="danger"
          icon="delete"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['system:dbClean:delete']">删除
        </el-button>
      </el-col>
    </el-row>

    <!--列表数据-->
    <el-table v-loading="loading" :data="dbCleanList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="ID" fixed="left" prop="id" sortable="custom" align="center" width="80">
        <template #default="scope">
          <span>{{ scope.row.id }}</span>
        </template>
      </el-table-column>
      <el-table-column label="名称" fixed="left" min-width="180px" :show-overflow-tooltip="true">
        <template #default="scope">
          <span class="link-type" @click="handleEdit(scope.row)">{{ scope.row.name }}</span>
        </template>
      </el-table-column>
      <el-table-column label="表名" min-width="150px" :show-overflow-tooltip="true">
        <template #default="scope">
          <span class="link-type" @click="handleCounts(scope.row)">{{ scope.row.tableName }}</span>
        </template>
      </el-table-column>
      <el-table-column label="时间字段" align="center" width="150px">
        <template #default="scope">
          <span>{{ scope.row.dateField }}</span>
        </template>
      </el-table-column>
      <el-table-column label="含附加条件" align="center" width="120">
        <template #default="scope">
          <span v-if="scope.row.extraCondition==null">
            <el-icon color="red">
              <CircleCloseFilled />
            </el-icon>
          </span>
          <span v-else>
            <el-icon color="green">
              <CircleCheckFilled />
            </el-icon>
          </span>
        </template>
      </el-table-column>
      <el-table-column label="状态" align="center" width="100">
        <template #default="scope">
          <span v-if="scope.row.status=='DISABLE'">
            <el-icon color="red">
              <CircleCloseFilled />
            </el-icon>
          </span>
          <span v-else>
            <el-icon color="green">
              <CircleCheckFilled />
            </el-icon>
          </span>
        </template>
      </el-table-column>
      <el-table-column label="删除类型" align="center" width="120">
        <template #default="scope">
          <span>{{ scope.row.cleanTypeName }}</span>
        </template>
      </el-table-column>
      <el-table-column label="最后一次更新时间" align="center" width="180">
        <template #default="scope">
          <span>{{ scope.row.lastCleanTime }}</span>
        </template>
      </el-table-column>
      <el-table-column label="最后一次更新条数" align="center" width="180">
        <template #default="scope">
          <span>{{ scope.row.lastCleanCounts }}</span>
        </template>
      </el-table-column>
      <el-table-column label="排序号" align="center">
        <template #default="scope">
          <span>{{ scope.row.orderIndex }}</span>
        </template>
      </el-table-column>
      <el-table-column label="创建时间" align="center" width="180">
        <template #default="scope">
          <span>{{ scope.row.createdTime }}</span>
        </template>
      </el-table-column>
      <el-table-column label="操作" align="center" width="140" fixed="right" class-name="small-padding fixed-width">
        <template #default="scope">
          <el-button
            link
            type="danger"
            icon="delete"
            @click="handleDelete(scope.row)"
            v-hasPermi="['system:dbClean:delete']">删除
          </el-button>
          <el-button
            link
            type="warning"
            icon="CircleCloseFilled"
            @click="handleClean(scope.row)"
            v-hasPermi="['system:dbClean:manualClean']">清理
          </el-button>
        </template>
      </el-table-column>
    </el-table>

    <pagination
      v-show="total > 0"
      :total="total"
      v-model:page="queryParams.page"
      v-model:limit="queryParams.pageSize"
      @pagination="getList" />

    <!-- 表单 -->
    <DBCleanForm ref="formRef" @success="getList" />

    <!-- 清理 -->
    <CleanForm ref="cleanFormRef" @success="getList" />

  </div>
</template>

<script setup name="DBCLean">
  import { fetchList, deleteDBClean, getTableCounts } from "@/api/system/dbClean";
  import DBCleanForm from './form.vue'
  import CleanForm from './clean.vue'

  const { proxy } = getCurrentInstance();
  const formRef = ref();
  const cleanFormRef = ref();

  // 遮罩层
  const loading = ref(true);
  // 选中数组
  const ids = ref([]);
  // 非单个禁用
  const single = ref(true);
  // 非多个禁用
  const multiple = ref(true);
  // 总条数
  const total = ref(0);
  // 查询列表数据
  const dbCleanList = ref([]);

  const data = reactive({
    queryParams: {
      page: 1,
      pageSize: 10
    }
  });

  const { queryParams } = toRefs(data);

  /** 获取总条数 */
  function handleCounts(row) {
    getTableCounts(row.id).then(
      response => {
        proxy.$modal.msgInfo('信息', '数据库表[' + row.tableName + ']数据总条数:' + response);
      }
    );
  }

  /** 清理 */
  function handleClean(row) {
    cleanFormRef.value.openClean(row.id);
  }

  /** 查询列表 */
  function getList() {
    loading.value = true;
    dbCleanList.value = [];
    fetchList(queryParams.value).then(
      response => {
        dbCleanList.value = response.rows;
        total.value = response.total;
        loading.value = false;
      }
    );
  }

  /** 搜索按钮操作 */
  function handleQuery() {
    getList();
  }

  /** 重置按钮操作 */
  function resetQuery() {
    proxy.resetForm("queryRef");
    queryParams.value.page = 1;
    handleQuery();
  }

  /** 新增按钮操作 */
  function handleCreate() {
    formRef.value.openForm(null, 'create');
  }

  /** 修改按钮操作 */
  function handleEdit(row) {
    const id = row.id || ids.value.join(",");
    formRef.value.openForm(id, 'edit');
  }

  /** 删除按钮操作 */
  function handleDelete(row) {
    const deleteIds = row.id || ids.value.join(",");
    proxy.$confirm('是否确认删除编号为"' + deleteIds + '"的数据项?', "警告", {
      confirmButtonText: "确定",
      cancelButtonText: "取消",
      type: "warning"
    }).then(function() {
      return deleteDBClean(deleteIds);
    }).then(() => {
      proxy.$modal.msgSuccess("删除成功");
      getList();
    }).catch(function() {});
  }

  // 多选框选中数据
  function handleSelectionChange(selection) {
    ids.value = selection.map(item => item.id)
    single.value = selection.length != 1
    multiple.value = !selection.length
  }

  /** 初始化 **/
  onMounted(() => {
    getList();
  })
</script>